How to: Delete a record from a table in Datasheet view.
Solution:
Open the Table Datasheet view, click on the 'Row Selector' for the record to select, and use the 'Cut' or 'Delete' command under the 'Edit' menu.
1) If the Database window is not active, activate the Database window.
2) Open the Table Datasheet view.
3) Click on the 'Row Selector' for the desired record to delete.
Row Selector
NOTE 1: To select multiple adjacent records, press and hold down SHIFT while selecting the 'Row Selector' for each record.
NOTE 2: To select multiple non-adjacent records, press and hold down CTRL while selecting the 'Row Selector' for each record.
4) Select the 'Edit' menu and select 'Cut' or 'Delete'.
5) (Optional) Select the 'File' menu and select 'Close' to close the Table Datasheet view. (The changes, that is, deletions, are automatically saved.)
